[MUSIC] Welcome to this video
on Assignment Overview: Data Warehouse Analysis with SQL. After watching this video,
you will be able to: identify the main objective of the assignment,
describe the tasks in the assignment. This assignment will guide you through
building a data warehouse module. To complete this assignment,
you will utilize the PostgreSQL database relational database service available as
part of IBM Skills Network Labs (SN Labs), Cloud IDE, a virtual lab
environment used in this course. You will create an instance of
IBM Db2 on the cloud by following the instructions in the provided link. If you have already created a Db2
instance in previous courses, you can continue using that to perform the
exercises, but you may need to clean up old tables in case your database
instance is running low on space. The first exercise requires you to
load the data provided by the company into the tables in CSV format
by performing a series of tasks. You will start by downloading
the data from the links provided and then loading that data into
the finproDimDate table, FinproDimBranches table,
finproDimCountries table, finproDimCities table,
finproDimAccountTypes table, finproDimCustomers table and
finproFactTransactions table. And after loading the data, you will take
a screenshot of the first five rows in each table and name the screenshot. In the second exercise, you will query
the loaded data by creating a grouping sets query, rollup query, and
cube query using the columns CustomerID, AccountID, and BranchCode collected. Finally, using the Branch and
Total Transaction columns, you will create a materialized query table
or MQT named Total_transaction_per_branch. After performing each task,
you will take a screenshot of the SQL and the output rows and
then name the screenshot. In this video, you learned that in
this assignment you will first load the data into the finproDimDate table,
finproDimBranches table, finproDimCountries table, finproDimCities
table, finproDimAccountTypes table, finproDimCustomers table, and
finproFactTransactions table. You will then query the loaded data
by creating a grouping sets query, rollup query, and
cube query using the columns CustomerID, AccountID, and BranchCode collected. [MUSIC]